Unit of Competency Mapping – Information for Teachers/Assessors – Information for Learners
ICTPRG402 Mapping and Delivery Guide
Apply query language
Version 1.0
Issue Date: May 2024
Qualification | - |
Unit of Competency | ICTPRG402 - Apply query language |
---|---|---|---|
Description | |||
Employability Skills | |||
Learning Outcomes and Application | This unit describes the skills and knowledge required to retrieve and manipulate information stored in information systems, using a query language.It applies to individuals in a range of work environments, who are required to extract information from a source such as a database, a text file, or an extensible markup language (XML), by creating and running queries.No licensing, legislative or certification requirements apply to this unit at the time of publication. | ||
Duration and Setting | X weeks, nominally xx hours, delivered in a classroom/online/blended learning setting. Gather evidence to demonstrate consistent performance in conditions that are safe and replicate the workplace. Noise levels, production flow, interruptions and time variances must be typical of those experienced in the programming and software development industry, and include access to: a data source resources in the chosen query language documentation regarding client and functionality requirements resources to aid calculation. Assessors must satisfy NVR/AQTF assessor requirements. |
||
Prerequisites/co-requisites | |||
Competency Field |
Development and validation strategy and guide for assessors and learners | Student Learning Resources | Handouts Activities |
Slides PPT |
Assessment 1 | Assessment 2 | Assessment 3 | Assessment 4 | |
---|---|---|---|---|---|---|---|---|
Elements of Competency | Performance Criteria | |||||||
Element: Determine the requirements of developing queries |
| |||||||
Element: Write queries to retrieve and sort values |
| |||||||
Element: Write queries to selectively retrieve values |
| |||||||
Element: Perform a calculation in queries |
|